------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  C:\Users\sgolder\Dropbox\Portfolio Allocation\replication\africancabinets_aux.log
  log type:  text
 opened on:  30 Mar 2017, 13:10:55

. set more off

. #delimit ;
delimiter now ;
. *     ***************************************************************** *;
. *     ***************************************************************** *;
. *       File-Name:      africancabinets_aux.do                          *;
. *       Date:           March 22, 2017                                  *;
. *       Author:         Molly Ariotti and Sona Golder                   *;
. *       Purpose:        Replicate auxilliary results for CPS portfolio  *;
. *                       allocation paper, using Africa data 1990-2014.  *;
. *           Input File:     aux_cabinet.dta                                 *;
. *       Output File:    africancabinets_aux.log                         *;
. *       Data Output:    none                                            *;
.              *       Previous file:  Africa_govts_aux.xls --> Stata .dta             *;
. *       Machine:        laptop                                                          *;
. *     ****************************************************************  *;
. *     ****************************************************************  *;
. *     ****************************************************************  *;
. *       Open and summarize dataset. This is the Africa_govt_obs.dta     *;
. *       with some additional variables: wealth, ethnic heterogeneity,   *;
. *       level of democracy, size of cabinet (number of ministers),      *;
. *       regime type (parl, pres, semi-pres) and pres (yes or no)        *;
.  *     ****************************************************************  *;
. use "\Users\sgolder\Dropbox\Portfolio Allocation\replication\aux_cabinet.dta";

. sum;

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
        name |          0
democratic~s |          0
     cabinet |         73     5.39726    3.946657          1         18
     cowcode |         73    479.1918    68.94818        403        590
        year |         73    2003.137    6.549629       1990       2014
-------------+---------------------------------------------------------
cabinetdates |          0
govtcoalit~n |         73           1           0          1          1
   have_data |         73    .3835616    .4896182          0          1
  regimetype |         73    1.191781     .738947          0          2
   govt_size |         68    21.30882     5.80853          9         37
-------------+---------------------------------------------------------
 eth_alesina |         61    .6504688    .1932137          0      .9084
   democracy |         61    7.311475    1.489306          6         10
gdp_consta~d |         70    1582.844    2147.264    205.072    8837.61
        pres |         73    .3835616    .4896182          0          1

. desc;

Contains data from \Users\sgolder\Dropbox\Portfolio Allocation\replication\aux_cabinet.dta
  obs:            73                          
 vars:            14                          30 Mar 2017 13:09
 size:         8,468                          
------------------------------------------------------------------------------------------------------------------
              storage   display    value
variable name   type    format     label      variable label
------------------------------------------------------------------------------------------------------------------
name            str44   %44s                  Name
democraticyears str24   %24s                  democratic years
cabinet         byte    %8.0g                 
cowcode         int     %8.0g                 
year            int     %8.0g                 
cabinetdates    str29   %29s                  cabinet dates
govtcoalition   byte    %8.0g                 govt coalition
have_data       byte    %8.0g                 
regimetype      byte    %8.0g                 regime type
govt_size       byte    %8.0g                 
eth_alesina     float   %8.0g                 eth_Alesina
democracy       byte    %8.0g                 
gdp_constant2~d float   %8.0g                 GDP_constant 2010 USD
pres            byte    %8.0g                 
------------------------------------------------------------------------------------------------------------------
Sorted by: 

. logit have_data gdp_constant2010usd pres democracy eth_alesina govt_size;

Iteration 0:   log likelihood = -39.336145  
Iteration 1:   log likelihood = -32.945772  
Iteration 2:   log likelihood =  -32.89428  
Iteration 3:   log likelihood = -32.894118  
Iteration 4:   log likelihood = -32.894118  

Logistic regression                             Number of obs     =         58
                                                LR chi2(5)        =      12.88
                                                Prob > chi2       =     0.0245
Log likelihood = -32.894118                     Pseudo R2         =     0.1638

-------------------------------------------------------------------------------------
          have_data |      Coef.   Std. Err.      z    P>|z|     [95% Conf. Interval]
--------------------+----------------------------------------------------------------
gdp_constant2010usd |   .0004351   .0002641     1.65   0.099    -.0000825    .0009528
               pres |   1.157513   .7507579     1.54   0.123    -.3139455    2.628972
          democracy |  -.0269185   .3656097    -0.07   0.941    -.7435003    .6896633
        eth_alesina |  -1.739756   1.638426    -1.06   0.288    -4.951012    1.471501
          govt_size |   .0996652   .0725769     1.37   0.170    -.0425828    .2419132
              _cons |    -2.6605   2.903494    -0.92   0.360    -8.351243    3.030244
-------------------------------------------------------------------------------------

. logit have_data gdp_constant2010usd regimetype democracy eth_alesina govt_size;

Iteration 0:   log likelihood = -39.336145  
Iteration 1:   log likelihood = -33.792931  
Iteration 2:   log likelihood = -33.775796  
Iteration 3:   log likelihood = -33.775787  
Iteration 4:   log likelihood = -33.775787  

Logistic regression                             Number of obs     =         58
                                                LR chi2(5)        =      11.12
                                                Prob > chi2       =     0.0490
Log likelihood = -33.775787                     Pseudo R2         =     0.1414

-------------------------------------------------------------------------------------
          have_data |      Coef.   Std. Err.      z    P>|z|     [95% Conf. Interval]
--------------------+----------------------------------------------------------------
gdp_constant2010usd |   .0004775   .0002808     1.70   0.089    -.0000728    .0010278
         regimetype |   .5621891   .6162549     0.91   0.362    -.6456484    1.770027
          democracy |  -.0415159   .3696372    -0.11   0.911    -.7659914    .6829596
        eth_alesina |  -1.841578   1.661274    -1.11   0.268    -5.097616     1.41446
          govt_size |   .0905816   .0697567     1.30   0.194     -.046139    .2273022
              _cons |  -2.459938   3.173039    -0.78   0.438    -8.678981    3.759104
-------------------------------------------------------------------------------------

. log close;
      name:  <unnamed>
       log:  C:\Users\sgolder\Dropbox\Portfolio Allocation\replication\africancabinets_aux.log
  log type:  text
 closed on:  30 Mar 2017, 13:10:55
------------------------------------------------------------------------------------------------------------------
